<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <link rel="canonical" href="https://blog.csdn.net/u010305706/article/details/52998947"/>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <meta name="renderer" content="webkit"/>
    <meta name="force-rendering" content="webkit"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="report" content='{"pid":"blog"}'>
    <meta name="referrer" content="always">
    <meta http-equiv="Cache-Control" content="no-siteapp" /><link rel="alternate" media="handheld" href="#" />
    <meta name="shenma-site-verification" content="5a59773ab8077d4a62bf469ab966a63b_1497598848">
        <meta name="csdn-baidu-search"  content='{"autorun":true,"install":true,"keyword":"MySQL时区设置 - peachli"}'>
    
    <link href="https://csdnimg.cn/public/favicon.ico" rel="SHORTCUT ICON">
    <title>MySQL时区设置 - peachli - CSDN博客</title>

        
                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/detail-3c56c08d12.min.css">
            
        
            <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-9b39979775.min.css">
        <script type="text/javascript">
        var username = "u010305706";
        var blog_address = "https://blog.csdn.net/u010305706";
        var static_host = "https://csdnimg.cn/release/phoenix/";
        var currentUserName = "";
        var isShowAds = true;
        var isOwner = false;
        var loginUrl = "http://passport.csdn.net/account/login?from=https://blog.csdn.net/u010305706/article/details/52998947"
        var blogUrl = "https://blog.csdn.net/";

        var curSkin = "skin3-template";
        // 收藏所需数据
        var articleTitle = "MySQL时区设置";
        var articleDesc = "MySQL时区默认是服务器的时区。可以通过以下命令查看SQL代码mysql>showvariableslike‘%time_zone%’;+——————+——–+|Variable_name|Value|+——————+——–+|system_time_zone|CST||time_zone|SYSTEM|";
        // 第四范式所需数据
        var articleTitles = "MySQL时区设置 - peachli";
        
        var nickName = "peach_li";
        var isCorporate = false;
        var subDomainBlogUrl = "https://blog.csdn.net/"
        var digg_base_url = "https://blog.csdn.net/u010305706/phoenix/comment";
        var articleDetailUrl = "https://blog.csdn.net/u010305706/article/details/52998947";
    </script>
    <script src="https://csdnimg.cn/public/common/libs/jquery/jquery-1.9.1.min.js" type="text/javascript"></script>
    <script src="//g.csdnimg.cn/??fixed-sidebar/1.1.3/fixed-sidebar.js,report/1.0.4/report.js" type="text/javascript"></script>
    <link rel="stylesheet" href="https://csdnimg.cn/public/sandalstrap/1.4/css/sandalstrap.min.css">
    <style>
        .MathJax, .MathJax_Message, .MathJax_Preview{
            display: none
        }
    </style>
</head>
<body class="nodata " > 
    <link rel="stylesheet" href="https://csdnimg.cn/public/common/toolbar/content_toolbar_css/content_toolbar.css">
    <script id="toolbar-tpl-scriptId" src="https://csdnimg.cn/public/common/toolbar/js/content_toolbar.js" type="text/javascript" domain="https://blog.csdn.net/"></script>
<div id="kp_box_476" data-pid="476" data-track-view='{"mod":"kp_popu_476-1490","con":",,"}' data-track-click='{"mod":"kp_popu_476-1490","con":",,"}' data-report-view='{"mod":"kp_popu_476-1490","keyword":""}' data-report-click='{"mod":"kp_popu_476-1490","keyword":""}'><script src="//csdnimg.cn/public/common/indexSuperise/1.1.1/indexSuperise.js?20190111165312"></script><script>window.csdn.indexSuperise({smallMoveImg:'https://img-bss.csdn.net/1565248701607.jpg',bigMoveImg:'https://img-bss.csdn.net/1565248693537.jpg',link:'https://kunyu.csdn.net?p=476&a=1490&c=652&k=&d=1&t=3&dest=https%3A%2F%2Fdeveloper.huaweicloud.com%2Fcompetition%2Fcompetitions%2F1000007620%2Fintroduction%3Futm_source%3Dcsdn%26utm_medium%3Dpr%26utm_campaign%3Dcsdntf%26utm_term%3Dgarbage',trackSuperId:476,smallMove:'notMove',trackSId:1490});</script></div><link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/blog_code-c3a0c33d5c.css">
<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-e040f0c7c8.css">

<script type="text/javascript">
	var NEWS_FEED = function(){}
</script>

<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/chart-3456820cac.css" />
<div class="container clearfix" id="mainBox">
			<div class="recommend-right">
  <ul class="recommend-fixed-box">
    
  </ul>
</div>	    <main>
        <div class="blog-content-box">
    <div class="article-header-box">
        <div class="article-header">
            <div class="article-title-box">
                <span class="article-type type-1 float-left">原</span>                <h1 class="title-article">MySQL时区设置</h1>
            </div>
            <div class="article-info-box">
                <div class="article-bar-top">
                                                                                                                                            <span class="time">2016年11月01日 19:19:31</span>
                    <a class="follow-nickName" href="https://me.csdn.net/u010305706" target="_blank">peach_li</a>
                    <span class="read-count">阅读数 10958</span>
                                                                        <span class="tags-box artic-tag-box">
                <span class="label">标签：</span>
                                                                <a data-report-click='{"mod":"popu_626","strategy":"mysql"}' data-report-view='{"mod":"popu_626","strategy":"mysql"}' class="tag-link" href="https://so.csdn.net/so/search/s.do?q=mysql&t=blog" target="_blank">mysql                                                    </a>
              </span>
                                                                            <div class="tags-box space">
                                <span class="label">个人分类：</span>
                                                                <a class="tag-link" href="https://blog.csdn.net/u010305706/article/category/3076271" target="_blank">数据库                                                                    </a>
                            </div>
                                                                                    </div>
                <div class="operating">
                                    </div>
            </div>
        </div>
    </div>
    <article class="baidu_pl">
                <div id="article_content" class="article_content clearfix">
                                                <div class="article-copyright">
                        
                        版权声明：本文为博主原创文章，未经博主允许不得转载。                        <a class="copy-right-url" href=" https://blog.csdn.net/u010305706/article/details/52998947"> https://blog.csdn.net/u010305706/article/details/52998947</a>
                    </div>
                                                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                                        <div id="content_views" class="markdown_views prism-atom-one-dark">
                    <!-- flowchart 箭头图标 勿删 -->
                    <svg xmlns="http://www.w3.org/2000/svg" style="display: none;">
                        <path stroke-linecap="round" d="M5,0 0,2.5 5,5z" id="raphael-marker-block" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"></path>
                    </svg>
                                            <p>MySQL 时区默认是服务器的时区。 <br>
可以通过以下命令查看 <br>
SQL代码 <br>
mysql&gt; show variables like ‘%time_zone%’; <br>
+——————+——–+ <br>
| Variable_name    | Value  | <br>
+——————+——–+ <br>
| system_time_zone | CST    | <br>
| time_zone        | SYSTEM | <br>
+——————+——–+ <br>
2 rows in set (0.00 sec) <br>
可以通过修改my.cnf <br>
在 [mysqld] 之下加</p>

<p>default-time-zone=timezone <br>
来修改时区。如： <br>
default-time-zone = ‘+8:00’ <br>
改了记得重启msyql喔 <br>
注意一定要在 [mysqld] 之下加 ，否则会出现 unknown variable ‘default-time-zone=+8:00’</p>

<p>另外也可以通过命令 set time_zone = timezone <br>
比如北京时间（GMT+0800） <br>
set time_zone = ‘+8:00’;</p>                                    </div>
                <link href="https://csdnimg.cn/release/phoenix/mdeditor/markdown_views-e44c3c0e64.css" rel="stylesheet">
                    </div>
    </article>
</div>

            <div class="hide-article-box hide-article-pos text-center">
            <a class="btn-readmore" data-report-view='{"mod":"popu_376","dest":"https://blog.csdn.net/u010305706/article/details/52998947","strategy":"readmore"}' data-report-click='{"mod":"popu_376","dest":"https://blog.csdn.net/u010305706/article/details/52998947","strategy":"readmore"}'>
                展开阅读全文
                <svg class="icon chevrondown" aria-hidden="true">
                    <use xlink:href="#csdnc-chevrondown"></use>
                </svg>
            </a>
        </div>
    
<script>
    $(".MathJax").remove();
    if ($('div.markdown_views pre.prettyprint code.hljs').length > 0) {
        $('div.markdown_views')[0].className = 'markdown_views';
    }
    var persentSet = 1;
</script>

<script src="https://csdnimg.cn/release/phoenix/vendor/linkCatcher/linkCatcher-3a08af3a5f.js"></script>        <div id="dmp_ad_58"><div id="kp_box_58" data-pid="58" data-track-view='{"mod":"kp_popu_58-402","con":",,"}' data-track-click='{"mod":"kp_popu_58-402","con":",,"}' data-report-view='{"mod":"kp_popu_58-402","keyword":""}' data-report-click='{"mod":"kp_popu_58-402","keyword":""}'><div style="width:100%;background:#fff;border:3px solid #fff;padding:16px 0px 0px 0px;">
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<div id="three_ad1" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 100,
                showid : 'ztvJV8',
                placeholderId: "three_ad1",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 0,
                    imageWidth: 90,
                    imageHeight: 68,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft YaHei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 20,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script>
</div></div></div>        <a id="commentBox"></a>
<div class="comment-box">
	
	<div class="comment-edit-box d-flex">
		<a id="commentsedit"></a>
		<div class="user-img">
			<a href="javascript:void(0);" target="_blank">
				<img class="show_loginbox" src="//g.csdnimg.cn/static/user-img/anonymous-User-img.png">
			</a>
		</div>
		<form id="commentform">
			<input type="hidden" id="comment_replyId">
			<textarea class="comment-content" name="comment_content" id="comment_content" placeholder="想对作者说点什么"></textarea>
			<div class="opt-box"> <!-- d-flex -->
				<div id="ubbtools" class="add_code">
					<a href="#insertcode" code="code" target="_self"><i class="icon iconfont icon-daima"></i></a>
				</div>
				<input type="hidden" id="comment_replyId" name="comment_replyId">
				<input type="hidden" id="article_id" name="article_id" value="52998947">
				<input type="hidden" id="comment_userId" name="comment_userId" value="">
				<input type="hidden" id="commentId" name="commentId" value="">
				<div style="display: none;" class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_384","dest":""}'><a href="#" target="_blank" class="comment_area_btn">发表评论</a></div>
				<div class="dropdown" id="myDrap">
					<a class="dropdown-face d-flex align-items-center" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
					<div class="txt-selected text-truncate">添加代码片</div>
					<svg class="icon d-block" aria-hidden="true">
						<use xlink:href="#csdnc-triangledown"></use>
					</svg>
					</a>
					<ul class="dropdown-menu" id="commentCode" aria-labelledby="drop4">
						<li><a data-code="html">HTML/XML</a></li>
						<li><a data-code="objc">objective-c</a></li>
						<li><a data-code="ruby">Ruby</a></li>
						<li><a data-code="php">PHP</a></li>
						<li><a data-code="csharp">C</a></li>
						<li><a data-code="cpp">C++</a></li>
						<li><a data-code="javascript">JavaScript</a></li>
						<li><a data-code="python">Python</a></li>
						<li><a data-code="java">Java</a></li>
						<li><a data-code="css">CSS</a></li>
						<li><a data-code="sql">SQL</a></li>
						<li><a data-code="plain">其它</a></li>
					</ul>
				</div>  
				<div class="right-box">
					<span id="tip_comment" class="tip">还能输入<em>1000</em>个字符</span>
					<input type="button" class="btn btn-sm btn-cancel d-none" value="取消回复">
					<input type="submit" class="btn btn-sm btn-red btn-comment" value="发表评论">
				</div>
			</div>
		</form>
	</div>

		<div class="comment-list-container">
		<a id="comments"></a>
		<div class="comment-list-box">
		</div>
		<div id="commentPage" class="pagination-box d-none"></div>
		<div class="opt-box text-center">
			<div class="btn btn-sm btn-link-blue" id="btnMoreComment"></div>
		</div>
	</div>
</div>
        <div class="recommend-box">
                            <div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/uncle_david/article/details/79566996","strategy":"BlogCommendFromMachineLearnPai2","index":"0"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/uncle_david/article/details/79566996","strategy":"BlogCommendFromMachineLearnPai2","index":"0"}'>
	<div class="content">
		<a href="https://blog.csdn.net/uncle_david/article/details/79566996" target="_blank" title="mysql 数据库 修改默认时区">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 数据库 修改默认<em>时区</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-15</span>
				<span class="read-num hover-hide">
					阅读数 
					3万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/uncle_david/article/details/79566996" target="_blank" title="mysql 数据库 修改默认时区">
				<span class="desc oneline">mysql数据库创建后。默认的时区比东八区少了八个小时。如果sql语句中使用到mysql的时间的话就会比正常时间少了八个小时。所以需要修改mysql的系统时区。使用mysql连接工具或者命令好工具都可...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/uncle_david">来自：	<span class="blog_title"> 大伟爱自由的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/ljj125896/article/details/89156157","strategy":"BlogCommendFromMachineLearnPai2","index":"1"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/ljj125896/article/details/89156157","strategy":"BlogCommendFromMachineLearnPai2","index":"1"}'>
	<div class="content">
		<a href="https://blog.csdn.net/ljj125896/article/details/89156157" target="_blank" title="mysql中的CST时区问题">
		<h4 class="text-truncate oneline">
				<em>mysql</em>中的CST<em>时区</em>问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-09</span>
				<span class="read-num hover-hide">
					阅读数 
					766</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/ljj125896/article/details/89156157" target="_blank" title="mysql中的CST时区问题">
				<span class="desc oneline">在项目操作过程发现了一个时区的问题，问题现象为sql打印的时间和数据库里面存储的时间不一样。后来发现问题原因为mysql的时区为CST。网上搜索了下CST时区，才发现这个时区已经被诟病已久。它居然能够...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/ljj125896">来自：	<span class="blog_title"> ljj125896的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_28018283/article/details/80109290","strategy":"BlogCommendFromMachineLearnPai2","index":"2"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_28018283/article/details/80109290","strategy":"BlogCommendFromMachineLearnPai2","index":"2"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_28018283/article/details/80109290" target="_blank" title="Mysql时间差8个小时？修改Mysql时区">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>时间差8个小时？修改<em>Mysql</em><em>时区</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-27</span>
				<span class="read-num hover-hide">
					阅读数 
					3万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_28018283/article/details/80109290" target="_blank" title="Mysql时间差8个小时？修改Mysql时区">
				<span class="desc oneline">个人博客在将rds的数据库迁移回了公司服务器的Docker后，编辑部的小姐姐找上了门来，我发的资讯看不见啦～尝试修改docker系统时区rm-rf/etc/localtimeln-s/usr/shar...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_28018283">来自：	<span class="blog_title"> LEON的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/yanankk/article/details/86153639","strategy":"BlogCommendFromMachineLearnPai2","index":"3"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/yanankk/article/details/86153639","strategy":"BlogCommendFromMachineLearnPai2","index":"3"}'>
	<div class="content">
		<a href="https://blog.csdn.net/yanankk/article/details/86153639" target="_blank" title="CST标准时间 MySQL查看和修改">
		<h4 class="text-truncate oneline">
				CST标准时间 <em>MySQL</em>查看和修改		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-09</span>
				<span class="read-num hover-hide">
					阅读数 
					537</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/yanankk/article/details/86153639" target="_blank" title="CST标准时间 MySQL查看和修改">
				<span class="desc oneline">查看：SELECTSTR_TO_DATE('FriSep2810:30:00CST2018','%W%M%d%H:%i:%SCST%Y')ASdate;修改：UPDATEt_tableSETtime=...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/yanankk">来自：	<span class="blog_title"> yanankk的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_59" data-pid="59" data-track-view='{"mod":"kp_popu_59-860","con":",,SQL"}' data-track-click='{"mod":"kp_popu_59-860","con":",,SQL"}' data-report-view='{"mod":"kp_popu_59-860","keyword":"SQL"}' data-report-click='{"mod":"kp_popu_59-860","keyword":"SQL"}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/109?positionId=59&queryWord=SQL" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/yueyeqingshan/article/details/72545788","strategy":"BlogCommendFromMachineLearnPai2","index":"4"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/yueyeqingshan/article/details/72545788","strategy":"BlogCommendFromMachineLearnPai2","index":"4"}'>
	<div class="content">
		<a href="https://blog.csdn.net/yueyeqingshan/article/details/72545788" target="_blank" title="mysql上的时间取出来后与数据库存储的时间对不上">
		<h4 class="text-truncate oneline">
				<em>mysql</em>上的时间取出来后与数据库存储的时间对不上		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-19</span>
				<span class="read-num hover-hide">
					阅读数 
					4819</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/yueyeqingshan/article/details/72545788" target="_blank" title="mysql上的时间取出来后与数据库存储的时间对不上">
				<span class="desc oneline">解决办法:将centos下时区都设定好 cst时区 然后修改mysql数据库可以参考http://www.jb51.net/article/84198.htm这篇文章 方法一：通过mysql命令行模式...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/yueyeqingshan">来自：	<span class="blog_title"> 青衫-CSDN博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_27663847/article/details/82996141","strategy":"BlogCommendFromBaidu","index":"5"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_27663847/article/details/82996141","strategy":"BlogCommendFromBaidu","index":"5"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_27663847/article/details/82996141" target="_blank" title="MySQL设置时区&amp;MySQL访问网络设置">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>设置</em><em>时区</em>&amp;<em>MySQL</em>访问网络<em>设置</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-10</span>
				<span class="read-num hover-hide">
					阅读数 
					87</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_27663847/article/details/82996141" target="_blank" title="MySQL设置时区&amp;MySQL访问网络设置">
				<span class="desc oneline">MySQL设置时区SELECTnow();setglobaltime_zone='+8:00';flushPRIVILEGES;</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_27663847">来自：	<span class="blog_title"> Godlike’s blog</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/vkingnew/article/details/82149726","strategy":"BlogCommendFromBaidu","index":"6"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/vkingnew/article/details/82149726","strategy":"BlogCommendFromBaidu","index":"6"}'>
	<div class="content">
		<a href="https://blog.csdn.net/vkingnew/article/details/82149726" target="_blank" title="MySQL 8.0.12 时区设置和修改">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 8.0.12 <em>时区</em><em>设置</em>和修改		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-28</span>
				<span class="read-num hover-hide">
					阅读数 
					7411</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/vkingnew/article/details/82149726" target="_blank" title="MySQL 8.0.12 时区设置和修改">
				<span class="desc oneline">1.查询系统支持当前的时区设置：mysql&amp;amp;gt;selectversion();+-----------+|version()|+-----------+|8.0.12|+---------...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/vkingnew">来自：	<span class="blog_title"> vkingnew 的技术博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/hopyGreat/article/details/81668150","strategy":"BlogCommendFromBaidu","index":"7"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/hopyGreat/article/details/81668150","strategy":"BlogCommendFromBaidu","index":"7"}'>
	<div class="content">
		<a href="https://blog.csdn.net/hopyGreat/article/details/81668150" target="_blank" title="修改MySQL的时区问题">
		<h4 class="text-truncate oneline">
				修改<em>MySQL</em>的<em>时区</em>问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-14</span>
				<span class="read-num hover-hide">
					阅读数 
					4585</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/hopyGreat/article/details/81668150" target="_blank" title="修改MySQL的时区问题">
				<span class="desc oneline">MySQL8添加了一些新特性，安全性也有很大的提升。导致的结果是在连接mysql的时候必须加入一个serverTimezone的参数，也就是jdbc:mysql://localhost/kg_demo...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/hopyGreat">来自：	<span class="blog_title"> hopyGreat的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/wyfcode/article/details/83152934","strategy":"BlogCommendFromBaidu","index":"8"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/wyfcode/article/details/83152934","strategy":"BlogCommendFromBaidu","index":"8"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wyfcode/article/details/83152934" target="_blank" title="windows下mysql时区设置">
		<h4 class="text-truncate oneline">
				windows下<em>mysql</em><em>时区</em><em>设置</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-18</span>
				<span class="read-num hover-hide">
					阅读数 
					3162</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wyfcode/article/details/83152934" target="_blank" title="windows下mysql时区设置">
				<span class="desc oneline">一，root身份登录MySQLmysql-u-root-p二，查看time_zone变量显示'％time_zone％'等变量;三，设置time_zone变量settime_zone='+08:00';...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wyfcode">来自：	<span class="blog_title"> 木木木的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_60" data-pid="60" data-track-view='{"mod":"kp_popu_60-43","con":",,"}' data-track-click='{"mod":"kp_popu_60-43","con":",,"}' data-report-view='{"mod":"kp_popu_60-43","keyword":""}' data-report-click='{"mod":"kp_popu_60-43","keyword":""}'><div id="three_ad8" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad8",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/WeiHao0240/article/details/86575561","strategy":"BlogCommendFromBaidu","index":"9"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/WeiHao0240/article/details/86575561","strategy":"BlogCommendFromBaidu","index":"9"}'>
	<div class="content">
		<a href="https://blog.csdn.net/WeiHao0240/article/details/86575561" target="_blank" title="MySQL如何修改时区">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>如何修改<em>时区</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-22</span>
				<span class="read-num hover-hide">
					阅读数 
					716</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/WeiHao0240/article/details/86575561" target="_blank" title="MySQL如何修改时区">
				<span class="desc oneline">MySQL修改时区方法一：MySQL命令行模式修改方法二：修改my.cnf配置文件方法一：MySQL命令行模式修改查看当前时区showvariableslike&amp;amp;amp;quot;%time_...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/WeiHao0240">来自：	<span class="blog_title"> Jack魏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/aa15237104245/article/details/83345232","strategy":"BlogCommendFromMachineLearnPai2","index":"10"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/aa15237104245/article/details/83345232","strategy":"BlogCommendFromMachineLearnPai2","index":"10"}'>
	<div class="content">
		<a href="https://blog.csdn.net/aa15237104245/article/details/83345232" target="_blank" title="mysql中设置时区">
		<h4 class="text-truncate oneline">
				<em>mysql</em>中<em>设置</em><em>时区</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-24</span>
				<span class="read-num hover-hide">
					阅读数 
					1372</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/aa15237104245/article/details/83345232" target="_blank" title="mysql中设置时区">
				<span class="desc oneline">首先,查看下mysql中使用的时区  showvariableslike'%time_zone%';测试查看下时间 selectnow();2018-10-2415:49:17这个应该是没有设置时区1...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/aa15237104245">来自：	<span class="blog_title"> Hero_孙的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
			<div class="recommend-item-box blog-expert-recommend-box">
			<div class="d-flex">
				<div class="blog-expert-recommend">
					<div class="blog-expert">
						<div class="blog-expert-flexbox"></div>
					</div>
				</div>
			</div>
		</div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_34874784/article/details/82120841","strategy":"BlogCommendFromMachineLearnPai2","index":"11"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_34874784/article/details/82120841","strategy":"BlogCommendFromMachineLearnPai2","index":"11"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_34874784/article/details/82120841" target="_blank" title="mysql 时区">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>时区</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-27</span>
				<span class="read-num hover-hide">
					阅读数 
					419</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_34874784/article/details/82120841" target="_blank" title="mysql 时区">
				<span class="desc oneline">sql修改setglobaltime_zone='+8:00'查看selectNOW()配置文件			default-time_zone='+8:00'					  ...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_34874784">来自：	<span class="blog_title"> qq_34874784的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/u013308504/article/details/82623463","strategy":"BlogCommendFromMachineLearnPai2","index":"12"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u013308504/article/details/82623463","strategy":"BlogCommendFromMachineLearnPai2","index":"12"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u013308504/article/details/82623463" target="_blank" title="mysql 与java 转换格式化格林威治时间（Tue Sep 13 00:00:00 CST 2016）两种方式">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 与java 转换格式化格林威治时间（Tue Sep 13 00:00:00 CST 2016）两种方式		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-11</span>
				<span class="read-num hover-hide">
					阅读数 
					911</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u013308504/article/details/82623463" target="_blank" title="mysql 与java 转换格式化格林威治时间（Tue Sep 13 00:00:00 CST 2016）两种方式">
				<span class="desc oneline">1 mysql中处理SELECTSTR_TO_DATE('ThuJul2015:04:03 2017','%a%b%e%T%Y%Y%Y')fromdual; STR_TO_DATE(REPLACE('...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u013308504">来自：	<span class="blog_title"> u013308504的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/newbie_907486852/article/details/80103284","strategy":"BlogCommendFromMachineLearnPai2","index":"13"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/newbie_907486852/article/details/80103284","strategy":"BlogCommendFromMachineLearnPai2","index":"13"}'>
	<div class="content">
		<a href="https://blog.csdn.net/newbie_907486852/article/details/80103284" target="_blank" title="一、MySQL数据库设置默认时区">
		<h4 class="text-truncate oneline">
				一、<em>MySQL</em>数据库<em>设置</em>默认<em>时区</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-27</span>
				<span class="read-num hover-hide">
					阅读数 
					3666</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/newbie_907486852/article/details/80103284" target="_blank" title="一、MySQL数据库设置默认时区">
				<span class="desc oneline">打开CMD将工作目录切换到MySQL的bin下mysql-uroot-p输入密码即可登陆MySQLselectnow();查看mysql系统时间。和当前时间做对比setglobaltime_zone=...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/newbie_907486852">来自：	<span class="blog_title"> 基督山伯爵的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_61" data-pid="61" data-track-view='{"mod":"kp_popu_61-557","con":",,"}' data-track-click='{"mod":"kp_popu_61-557","con":",,"}' data-report-view='{"mod":"kp_popu_61-557","keyword":""}' data-report-click='{"mod":"kp_popu_61-557","keyword":""}'><div id="three_ad13" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad13",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/zr527397749/article/details/81562697","strategy":"BlogCommendFromMachineLearnPai2","index":"14"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/zr527397749/article/details/81562697","strategy":"BlogCommendFromMachineLearnPai2","index":"14"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zr527397749/article/details/81562697" target="_blank" title="mysql8 设置时区">
		<h4 class="text-truncate oneline">
				<em>mysql</em>8 <em>设置</em><em>时区</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-10</span>
				<span class="read-num hover-hide">
					阅读数 
					3610</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zr527397749/article/details/81562697" target="_blank" title="mysql8 设置时区">
				<span class="desc oneline">jdbc:mysql://localhost:3306/airport?useUnicode=true&amp;amp;amp;characterEncoding=UTF-8&amp;amp;amp;useOldAl...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zr527397749">来自：	<span class="blog_title"> 千里之行,始于足下</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/daqiang012/article/details/81111525","strategy":"BlogCommendFromBaidu","index":"15"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/daqiang012/article/details/81111525","strategy":"BlogCommendFromBaidu","index":"15"}'>
	<div class="content">
		<a href="https://blog.csdn.net/daqiang012/article/details/81111525" target="_blank" title="activiti-explorer数据库连接报The server time zone value '???ú±ê×??±??' is unrecognized or represents more">
		<h4 class="text-truncate oneline">
				activiti-explorer数据库连接报The server time zone value '???ú±ê×??±??' is unrecognized or represents more		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-19</span>
				<span class="read-num hover-hide">
					阅读数 
					538</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/daqiang012/article/details/81111525" target="_blank" title="activiti-explorer数据库连接报The server time zone value '???ú±ê×??±??' is unrecognized or represents more">
				<span class="desc oneline">报错信息：java.sql.SQLException:Theservertimezonevalue'???ú±ê×??±??'isunrecognizedorrepresentsmorethanone...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/daqiang012">来自：	<span class="blog_title"> 大强的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/huangyuehong914/article/details/81742039","strategy":"BlogCommendFromBaidu","index":"16"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/huangyuehong914/article/details/81742039","strategy":"BlogCommendFromBaidu","index":"16"}'>
	<div class="content">
		<a href="https://blog.csdn.net/huangyuehong914/article/details/81742039" target="_blank" title="修改mysql数据库的时区">
		<h4 class="text-truncate oneline">
				修改<em>mysql</em>数据库的<em>时区</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-16</span>
				<span class="read-num hover-hide">
					阅读数 
					8428</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/huangyuehong914/article/details/81742039" target="_blank" title="修改mysql数据库的时区">
				<span class="desc oneline">#查看数据库时区mysql&amp;amp;gt;showvariableslike'%time_zone%';+------------------+--------+|Variable_name|Valu...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/huangyuehong914">来自：	<span class="blog_title"> 白日梦想家的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/io97704842/article/details/83094828","strategy":"BlogCommendFromBaidu","index":"17"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/io97704842/article/details/83094828","strategy":"BlogCommendFromBaidu","index":"17"}'>
	<div class="content">
		<a href="https://blog.csdn.net/io97704842/article/details/83094828" target="_blank" title="设置MySQL时区">
		<h4 class="text-truncate oneline">
				<em>设置</em><em>MySQL</em><em>时区</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-16</span>
				<span class="read-num hover-hide">
					阅读数 
					412</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/io97704842/article/details/83094828" target="_blank" title="设置MySQL时区">
				<span class="desc oneline">数据源添加&amp;amp;amp;serverTimezone=Asia/Shanghaiurl:'jdbc:mysql://gofbox.com:3306/arseeu?autoReconnect=tru...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/io97704842">来自：	<span class="blog_title"> 李陈毅的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/mu399/article/details/82225901","strategy":"BlogCommendFromBaidu","index":"18"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/mu399/article/details/82225901","strategy":"BlogCommendFromBaidu","index":"18"}'>
	<div class="content">
		<a href="https://blog.csdn.net/mu399/article/details/82225901" target="_blank" title="Mysql 时间与时区">
		<h4 class="text-truncate oneline">
				<em>Mysql</em> 时间与<em>时区</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-30</span>
				<span class="read-num hover-hide">
					阅读数 
					2083</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/mu399/article/details/82225901" target="_blank" title="Mysql 时间与时区">
				<span class="desc oneline">再Mysql,或者Mariadb命令行里运行selectnow();+---------------------+|now()|+---------------------+|2018-08-3017...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/mu399">来自：	<span class="blog_title"> mu399的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_62" data-pid="62" data-track-view='{"mod":"kp_popu_62-556","con":",,"}' data-track-click='{"mod":"kp_popu_62-556","con":",,"}' data-report-view='{"mod":"kp_popu_62-556","keyword":""}' data-report-click='{"mod":"kp_popu_62-556","keyword":""}'><div id="three_ad18" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad18",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/xianshigudu/article/details/82748049","strategy":"BlogCommendFromBaidu","index":"19"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/xianshigudu/article/details/82748049","strategy":"BlogCommendFromBaidu","index":"19"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xianshigudu/article/details/82748049" target="_blank" title="MySql8设置时区">
		<h4 class="text-truncate oneline">
				<em>MySql</em>8<em>设置</em><em>时区</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-17</span>
				<span class="read-num hover-hide">
					阅读数 
					681</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xianshigudu/article/details/82748049" target="_blank" title="MySql8设置时区">
				<span class="desc oneline">https://blog.csdn.net/qq631431929/article/details/51731834</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xianshigudu">来自：	<span class="blog_title"> xianshigudu的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/ab200814787/article/details/79406632","strategy":"BlogCommendFromBaidu","index":"20"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/ab200814787/article/details/79406632","strategy":"BlogCommendFromBaidu","index":"20"}'>
	<div class="content">
		<a href="https://blog.csdn.net/ab200814787/article/details/79406632" target="_blank" title="mysql中时区问题">
		<h4 class="text-truncate oneline">
				<em>mysql</em>中<em>时区</em>问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-28</span>
				<span class="read-num hover-hide">
					阅读数 
					875</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/ab200814787/article/details/79406632" target="_blank" title="mysql中时区问题">
				<span class="desc oneline">今天做查询遇到一个奇怪的事情,就是查询两个日期之间的记录,明明在sql客户端运行可以查到但是在项目中查询不出结果,后来发现是时区问题,我用的是springboot+mybatis项目,直接在连接url...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/ab200814787">来自：	<span class="blog_title"> 石头的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/zhangchao19890805/article/details/52690473","strategy":"BlogCommendFromBaidu","index":"21"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/zhangchao19890805/article/details/52690473","strategy":"BlogCommendFromBaidu","index":"21"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhangchao19890805/article/details/52690473" target="_blank" title="Docker 的 MySQL 官方镜像如何设置时区">
		<h4 class="text-truncate oneline">
				Docker 的 <em>MySQL</em> 官方镜像如何<em>设置</em><em>时区</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-28</span>
				<span class="read-num hover-hide">
					阅读数 
					5855</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhangchao19890805/article/details/52690473" target="_blank" title="Docker 的 MySQL 官方镜像如何设置时区">
				<span class="desc oneline">场景在DockerHub中的MySQL官方镜像中，时区是使用了世界标准时间(UTC)。因为在中国使用，所以需要把时区改成东八区的。...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhangchao19890805">来自：	<span class="blog_title"> zhangchao19890805的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/php521php/article/details/46867667","strategy":"BlogCommendFromBaidu","index":"22"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/php521php/article/details/46867667","strategy":"BlogCommendFromBaidu","index":"22"}'>
	<div class="content">
		<a href="https://blog.csdn.net/php521php/article/details/46867667" target="_blank" title="MySQL时区修改">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>时区</em>修改		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-13</span>
				<span class="read-num hover-hide">
					阅读数 
					3175</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/php521php/article/details/46867667" target="_blank" title="MySQL时区修改">
				<span class="desc oneline">MySQL时区修改</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/php521php">来自：	<span class="blog_title"> Jacson_Bai</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/392089775","strategy":"BlogCommendFromBaidu","index":"23"}' data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/392089775","strategy":"BlogCommendFromBaidu","index":"23"}'>
	<a href="https://bbs.csdn.net/topics/392089775" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mysql</em>中如何将Wed Feb 22 08:00:00 CST 2017格式的数据转换成yyyy-MM-dd		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">02-22</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">Wed Feb 22 08:00:00 CST 2017 这种格式是date的默认格式还是啥，希望能解答一下</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_63" data-pid="63" data-track-view='{"mod":"kp_popu_63-1059","con":",,"}' data-track-click='{"mod":"kp_popu_63-1059","con":",,"}' data-report-view='{"mod":"kp_popu_63-1059","keyword":""}' data-report-click='{"mod":"kp_popu_63-1059","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/234?positionId=63&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_22985751/article/details/80239784","strategy":"BlogCommendFromBaidu","index":"24"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_22985751/article/details/80239784","strategy":"BlogCommendFromBaidu","index":"24"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_22985751/article/details/80239784" target="_blank" title="一次JDBC与MySQL因“CST”时区协商误解导致时间差了14或13小时的排错经历">
		<h4 class="text-truncate oneline">
				一次JDBC与<em>MySQL</em>因“CST”<em>时区</em>协商误解导致时间差了14或13小时的排错经历		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-08</span>
				<span class="read-num hover-hide">
					阅读数 
					2434</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_22985751/article/details/80239784" target="_blank" title="一次JDBC与MySQL因“CST”时区协商误解导致时间差了14或13小时的排错经历">
				<span class="desc oneline">转自：https://www.aliyun.com/jiaocheng/799399.html摘要：###摘要名为CST的时区是一个很混乱的时区,在与MySQL协商会话时区时,Java会误以为是`CS...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_22985751">来自：	<span class="blog_title"> 埋头苦干中</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/Koupoo/article/details/7470184","strategy":"BlogCommendFromBaidu","index":"25"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/Koupoo/article/details/7470184","strategy":"BlogCommendFromBaidu","index":"25"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Koupoo/article/details/7470184" target="_blank" title="24时区，GMT，UTC，DST，CST时间详解">
		<h4 class="text-truncate oneline">
				24<em>时区</em>，GMT，UTC，DST，CST时间详解		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-17</span>
				<span class="read-num hover-hide">
					阅读数 
					1217</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Koupoo/article/details/7470184" target="_blank" title="24时区，GMT，UTC，DST，CST时间详解">
				<span class="desc oneline">许多人都知道两地时间表简称为GMT或UTC，而世界时区表则通称为WorldTime，那么GMT与UTC的实质原意又是为何？世界时区又是怎么区分的？面盘上密密麻麻的英文单字代表着什么意义与作用呢？这些都...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Koupoo">来自：	<span class="blog_title"> SlimApp</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_34874784/article/details/82026202","strategy":"BlogCommendFromBaidu","index":"26"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_34874784/article/details/82026202","strategy":"BlogCommendFromBaidu","index":"26"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_34874784/article/details/82026202" target="_blank" title="docker mysql 时区不对">
		<h4 class="text-truncate oneline">
				docker <em>mysql</em> <em>时区</em>不对		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-24</span>
				<span class="read-num hover-hide">
					阅读数 
					3706</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_34874784/article/details/82026202" target="_blank" title="docker mysql 时区不对">
				<span class="desc oneline">方法一：临时修改执行sql修改，重启后失效，setglobaltime_zone='+8:00'查看是否修改成功，selectNOW()方法二：永久修改生成容器时加上-eTZ=Asia/Shangha...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_34874784">来自：	<span class="blog_title"> qq_34874784的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/outjenny/article/details/81315776","strategy":"BlogCommendFromBaidu","index":"27"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/outjenny/article/details/81315776","strategy":"BlogCommendFromBaidu","index":"27"}'>
	<div class="content">
		<a href="https://blog.csdn.net/outjenny/article/details/81315776" target="_blank" title="jdbc连接mysql时报时区设置错误解决方法">
		<h4 class="text-truncate oneline">
				jdbc连接<em>mysql</em>时报<em>时区</em><em>设置</em>错误解决方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-31</span>
				<span class="read-num hover-hide">
					阅读数 
					1510</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/outjenny/article/details/81315776" target="_blank" title="jdbc连接mysql时报时区设置错误解决方法">
				<span class="desc oneline">参考https://blog.csdn.net/zqb765720343/article/details/80076020，感谢分享。jdbc连接mysql时报时区设置错误，提示相差8小时。1、在my...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/outjenny">来自：	<span class="blog_title"> outjenny的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/wm609972715/article/details/82890678","strategy":"BlogCommendFromBaidu","index":"28"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/wm609972715/article/details/82890678","strategy":"BlogCommendFromBaidu","index":"28"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wm609972715/article/details/82890678" target="_blank" title="MySQL 异常：时区错误">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 异常：<em>时区</em>错误		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-28</span>
				<span class="read-num hover-hide">
					阅读数 
					4893</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wm609972715/article/details/82890678" target="_blank" title="MySQL 异常：时区错误">
				<span class="desc oneline">1、时区错误异常信息为：Theservertimezonevalue'ÖÐ¹ú±ê×¼Ê±¼ä'isunrecognizedorrepresentsmorethanonetimezone.Youmus...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wm609972715">来自：	<span class="blog_title"> wm609972715的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_64" data-pid="64" data-track-view='{"mod":"kp_popu_64-81","con":",,"}' data-track-click='{"mod":"kp_popu_64-81","con":",,"}' data-report-view='{"mod":"kp_popu_64-81","keyword":""}' data-report-click='{"mod":"kp_popu_64-81","keyword":""}'><div id="three_ad28" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad28",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/to_Date32/article/details/82854237","strategy":"BlogCommendFromBaidu","index":"29"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/to_Date32/article/details/82854237","strategy":"BlogCommendFromBaidu","index":"29"}'>
	<div class="content">
		<a href="https://blog.csdn.net/to_Date32/article/details/82854237" target="_blank" title="Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvid">
		<h4 class="text-truncate oneline">
				Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvid		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-26</span>
				<span class="read-num hover-hide">
					阅读数 
					550</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/to_Date32/article/details/82854237" target="_blank" title="Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvid">
				<span class="desc oneline">最近有一个老项目做二开，项目使用了SSH架构，c3p0作为数据库连接池，但是项目启动的时候，tomcat会卡在下面这行代码：Initializingconnectionprovider:org.spr...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/to_Date32">来自：	<span class="blog_title"> to_Date32的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_42253523/article/details/84346978","strategy":"BlogCommendFromBaidu","index":"30"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_42253523/article/details/84346978","strategy":"BlogCommendFromBaidu","index":"30"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_42253523/article/details/84346978" target="_blank" title="mysql时区处理">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>时区</em>处理		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-22</span>
				<span class="read-num hover-hide">
					阅读数 
					91</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_42253523/article/details/84346978" target="_blank" title="mysql时区处理">
				<span class="desc oneline">查询MySQL数据库时间selectcurtime()查询时区信息showvariableslike&amp;quot;%time_zone%&amp;quot;;更改时区为东8区setglobaltime_zone...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_42253523">来自：	<span class="blog_title"> ZHAO的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/80509262","strategy":"BlogCommendFromBaidu","index":"31"}' data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/80509262","strategy":"BlogCommendFromBaidu","index":"31"}'>
	<a href="https://bbs.csdn.net/topics/80509262" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>时区</em>问题		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">05-03</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">表中有一个datetime字段是由服务器所在时区插入的当前时间，能不能从sql语句中取出服务器所在的时区（如-8），如何在sql中把这个字段转换成我想要的时区的时间</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/lioufei0370/article/details/85124246","strategy":"BlogCommendFromBaidu","index":"32"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/lioufei0370/article/details/85124246","strategy":"BlogCommendFromBaidu","index":"32"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lioufei0370/article/details/85124246" target="_blank" title="mysql时区修改">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>时区</em>修改		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-20</span>
				<span class="read-num hover-hide">
					阅读数 
					236</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lioufei0370/article/details/85124246" target="_blank" title="mysql时区修改">
				<span class="desc oneline">showvariableslike'%time_zone%';setglobaltime_zone='+8:00';```</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lioufei0370">来自：	<span class="blog_title"> lioufei0370的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_25158359/article/details/81093351","strategy":"BlogCommendFromBaidu","index":"33"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_25158359/article/details/81093351","strategy":"BlogCommendFromBaidu","index":"33"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_25158359/article/details/81093351" target="_blank" title="Mysql8链接时时区">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>8链接时<em>时区</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-18</span>
				<span class="read-num hover-hide">
					阅读数 
					2967</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_25158359/article/details/81093351" target="_blank" title="Mysql8链接时时区">
				<span class="desc oneline">jdbc:mysql://root:password@127.0.0.1:3306/leopard?useUnicode=true&amp;amp;amp;characterEncoding=UTF8&amp;amp...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_25158359">来自：	<span class="blog_title"> CrazyShaQiuShi</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_65" data-pid="65" data-track-view='{"mod":"kp_popu_65-1061","con":",,"}' data-track-click='{"mod":"kp_popu_65-1061","con":",,"}' data-report-view='{"mod":"kp_popu_65-1061","keyword":""}' data-report-click='{"mod":"kp_popu_65-1061","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/236?positionId=65&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/xx326664162/article/details/81947548","strategy":"BlogCommendFromBaidu","index":"34"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/xx326664162/article/details/81947548","strategy":"BlogCommendFromBaidu","index":"34"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xx326664162/article/details/81947548" target="_blank" title="关于Mysql 的时区问题">
		<h4 class="text-truncate oneline">
				关于<em>Mysql</em> 的<em>时区</em>问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-22</span>
				<span class="read-num hover-hide">
					阅读数 
					5617</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xx326664162/article/details/81947548" target="_blank" title="关于Mysql 的时区问题">
				<span class="desc oneline">问题：遇到这样一个问题，Mysql的时区，没有设置，默认是时区是0，在java代码中对应的字段类型是TimeStamp，mysql字段类型也是TimeStamp项目A代码中获取到的时间是正确的。写到数...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xx326664162">来自：	<span class="blog_title"> 薛瑄的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_33293878/article/details/89532459","strategy":"BlogCommendFromBaidu","index":"35"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_33293878/article/details/89532459","strategy":"BlogCommendFromBaidu","index":"35"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_33293878/article/details/89532459" target="_blank" title="设置mysql时区">
		<h4 class="text-truncate oneline">
				<em>设置</em><em>mysql</em><em>时区</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-26</span>
				<span class="read-num hover-hide">
					阅读数 
					119</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_33293878/article/details/89532459" target="_blank" title="设置mysql时区">
				<span class="desc oneline">1)查看mysql时区：showvariableslike&quot;%time_zone%&quot;;2)解决方法：1.在原来的参数“url”后面，拼上这个字符串：?serverTimezone=GMT%2B8，如：...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_33293878">来自：	<span class="blog_title"> qq_33293878的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/phs999/article/details/81253385","strategy":"BlogCommendFromBaidu","index":"36"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/phs999/article/details/81253385","strategy":"BlogCommendFromBaidu","index":"36"}'>
	<div class="content">
		<a href="https://blog.csdn.net/phs999/article/details/81253385" target="_blank" title="高版本MySQL（5.7,5.8）的JDBC连接新问题">
		<h4 class="text-truncate oneline">
				高版本<em>MySQL</em>（5.7,5.8）的JDBC连接新问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-27</span>
				<span class="read-num hover-hide">
					阅读数 
					8664</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/phs999/article/details/81253385" target="_blank" title="高版本MySQL（5.7,5.8）的JDBC连接新问题">
				<span class="desc oneline">在使用JDBC连接访问MySQL时一般要使用对应版本的驱动。比如我使用了8.0.11版本的MySQL，对应驱动的Maven描述为：&amp;amp;amp;lt;dependency&amp;amp;amp;gt;&amp;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/phs999">来自：	<span class="blog_title"> phs999的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/Elena_jun/article/details/82191071","strategy":"BlogCommendFromBaidu","index":"37"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/Elena_jun/article/details/82191071","strategy":"BlogCommendFromBaidu","index":"37"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Elena_jun/article/details/82191071" target="_blank" title="mysql时区异常">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>时区</em>异常		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-29</span>
				<span class="read-num hover-hide">
					阅读数 
					625</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Elena_jun/article/details/82191071" target="_blank" title="mysql时区异常">
				<span class="desc oneline">使用mysql-connector-java-8.0.9-rc出现以下异常：解决方案：在url后面添加&amp;amp;amp;serverTimezone=GMT%2B8，如：url:jdbc:mysql:...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Elena_jun">来自：	<span class="blog_title"> Elena_jun的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/ljasdf123/article/details/30506023","strategy":"BlogCommendFromBaidu","index":"38"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/ljasdf123/article/details/30506023","strategy":"BlogCommendFromBaidu","index":"38"}'>
	<div class="content">
		<a href="https://blog.csdn.net/ljasdf123/article/details/30506023" target="_blank" title="Access denied; you need (at least one of) the RELOAD privilege(s) for this operation">
		<h4 class="text-truncate oneline">
				Access denied; you need (at least one of) the RELOAD privilege(s) for this operation		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-13</span>
				<span class="read-num hover-hide">
					阅读数 
					4万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/ljasdf123/article/details/30506023" target="_blank" title="Access denied; you need (at least one of) the RELOAD privilege(s) for this operation">
				<span class="desc oneline">1.reload是administrative级的权限，即serveradministration；这类权限包括：CREATEUSER,PROCESS,RELOAD,REPLICATIONCLIENT...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/ljasdf123">来自：	<span class="blog_title"> ljasdf123的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_66" data-pid="66" data-track-view='{"mod":"kp_popu_66-87","con":",,"}' data-track-click='{"mod":"kp_popu_66-87","con":",,"}' data-report-view='{"mod":"kp_popu_66-87","keyword":""}' data-report-click='{"mod":"kp_popu_66-87","keyword":""}'><div id="three_ad38" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad38",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/dandan520520/article/details/79768825","strategy":"BlogCommendFromBaidu","index":"39"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/dandan520520/article/details/79768825","strategy":"BlogCommendFromBaidu","index":"39"}'>
	<div class="content">
		<a href="https://blog.csdn.net/dandan520520/article/details/79768825" target="_blank" title="25，MySQL 8.0参考手册 5.1.10 MySQL服务器时区支持">
		<h4 class="text-truncate oneline">
				25，<em>MySQL</em> 8.0参考手册 5.1.10 <em>MySQL</em>服务器<em>时区</em>支持		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-31</span>
				<span class="read-num hover-hide">
					阅读数 
					402</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/dandan520520/article/details/79768825" target="_blank" title="25，MySQL 8.0参考手册 5.1.10 MySQL服务器时区支持">
				<span class="desc oneline">MySQL服务器维护几个时区设置：系统时区。当服务器启动时，它会尝试确定主机的时区并使用它来设置system_time_zone系统变量。该值此后不会改变。您可以在启动时使用mysqld_safe 选...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/dandan520520">来自：	<span class="blog_title"> dandan520520的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/I_can_Fly_/article/details/84877782","strategy":"BlogCommendFromBaidu","index":"40"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/I_can_Fly_/article/details/84877782","strategy":"BlogCommendFromBaidu","index":"40"}'>
	<div class="content">
		<a href="https://blog.csdn.net/I_can_Fly_/article/details/84877782" target="_blank" title="使用最新版MySQL的jdbc驱动关于时区引发的问题">
		<h4 class="text-truncate oneline">
				使用最新版<em>MySQL</em>的jdbc驱动关于<em>时区</em>引发的问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-20</span>
				<span class="read-num hover-hide">
					阅读数 
					468</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/I_can_Fly_/article/details/84877782" target="_blank" title="使用最新版MySQL的jdbc驱动关于时区引发的问题">
				<span class="desc oneline">[size=large]Causedby:java.sql.SQLException:Theservertimezonevalue...[/size][size=medium]报错内容：[/size]...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/I_can_Fly_">来自：	<span class="blog_title"> I_can_Fly_的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_22978533/article/details/80270460","strategy":"BlogCommendFromBaidu","index":"41"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_22978533/article/details/80270460","strategy":"BlogCommendFromBaidu","index":"41"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_22978533/article/details/80270460" target="_blank" title="mysql 时区-时间转换">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>时区</em>-时间转换		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-10</span>
				<span class="read-num hover-hide">
					阅读数 
					2009</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_22978533/article/details/80270460" target="_blank" title="mysql 时区-时间转换">
				<span class="desc oneline">时区（timezone）转换函数：convert_tz(dt,from_tz,to_tz)selectconvert_tz('2008-08-0812:00:00','+08:00','+00:00'...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_22978533">来自：	<span class="blog_title"> qq_22978533的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/cn_1937/article/details/81698736","strategy":"BlogCommendFromBaidu","index":"42"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/cn_1937/article/details/81698736","strategy":"BlogCommendFromBaidu","index":"42"}'>
	<div class="content">
		<a href="https://blog.csdn.net/cn_1937/article/details/81698736" target="_blank" title="MySQL如何存储带有时区信息的时间？（windows/linux/mac下）">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>如何存储带有<em>时区</em>信息的时间？（windows/linux/mac下）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-15</span>
				<span class="read-num hover-hide">
					阅读数 
					983</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/cn_1937/article/details/81698736" target="_blank" title="MySQL如何存储带有时区信息的时间？（windows/linux/mac下）">
				<span class="desc oneline">写在前面因为默认情况下MySQL的表中是没有存储时区相关的信息的。因此我们需要下载一些时区表的文件，然后添加到Mysql的配置路径中。window系统如果你用的是windows操作系统在http://...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/cn_1937">来自：	<span class="blog_title"> D先生的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/jianai858/article/details/78059198","strategy":"BlogCommendFromBaidu","index":"43"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/jianai858/article/details/78059198","strategy":"BlogCommendFromBaidu","index":"43"}'>
	<div class="content">
		<a href="https://blog.csdn.net/jianai858/article/details/78059198" target="_blank" title="mysql 时区转换">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>时区</em>转换		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-22</span>
				<span class="read-num hover-hide">
					阅读数 
					1569</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/jianai858/article/details/78059198" target="_blank" title="mysql 时区转换">
				<span class="desc oneline">在做数据分析时，有些点击流数据是按照格林威治标准时间GMT来记录的，这时就需要对时间进行转换。参数1：需要转换的时间参数2：格林威治标准时间GMT参数3：北京时间，提前8小时SELECTCONVERT...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/jianai858">来自：	<span class="blog_title"> jianai858的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_67" data-pid="67" data-track-view='{"mod":"kp_popu_67-658","con":",,"}' data-track-click='{"mod":"kp_popu_67-658","con":",,"}' data-report-view='{"mod":"kp_popu_67-658","keyword":""}' data-report-click='{"mod":"kp_popu_67-658","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3573058",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/wsy__1993/article/details/52843471","strategy":"BlogCommendFromBaidu","index":"44"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/wsy__1993/article/details/52843471","strategy":"BlogCommendFromBaidu","index":"44"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wsy__1993/article/details/52843471" target="_blank" title="MySQL时区的问题">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>时区</em>的问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-17</span>
				<span class="read-num hover-hide">
					阅读数 
					863</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wsy__1993/article/details/52843471" target="_blank" title="MySQL时区的问题">
				<span class="desc oneline">查看时区：SHOWVARIABLESLIKE'%time_zone%';如果时区为CST，需要修改。修改方法：SET time_zone='+8:00';...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wsy__1993">来自：	<span class="blog_title"> wsy__1993的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/robinson_0612/article/details/78952842","strategy":"BlogCommendFromBaidu","index":"45"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/robinson_0612/article/details/78952842","strategy":"BlogCommendFromBaidu","index":"45"}'>
	<div class="content">
		<a href="https://blog.csdn.net/robinson_0612/article/details/78952842" target="_blank" title="MySQL 5.7 时间显示修改(log_timestamps UTC)">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 5.7 时间显示修改(log_timestamps UTC)		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-02</span>
				<span class="read-num hover-hide">
					阅读数 
					3080</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/robinson_0612/article/details/78952842" target="_blank" title="MySQL 5.7 时间显示修改(log_timestamps UTC)">
				<span class="desc oneline">在MySQL5.7版本中，日志记录时间发生了变化，使用了UTC方式来记录日志时间，也就是说这是个世界统一时间，与我们常用的本地时间不协调，因此，初始化MySQL5.7之后，需要对此做出调整，如下本文的...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/robinson_0612">来自：	<span class="blog_title"> 乐沙弥的世界</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/jumewo/article/details/50628526","strategy":"BlogCommendFromBaidu","index":"46"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/jumewo/article/details/50628526","strategy":"BlogCommendFromBaidu","index":"46"}'>
	<div class="content">
		<a href="https://blog.csdn.net/jumewo/article/details/50628526" target="_blank" title="mysql 时区与时间函数">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>时区</em>与时间函数		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-03</span>
				<span class="read-num hover-hide">
					阅读数 
					4441</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/jumewo/article/details/50628526" target="_blank" title="mysql 时区与时间函数">
				<span class="desc oneline">--在mysql中可以直接使用sleep()函数,sysdate函数返回的是执行到当前函数的时间,而now函数返回的是执行sql的时间mysql&gt;SELECTnow(),SYSDATE(),SLEEP...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/jumewo">来自：	<span class="blog_title"> rudy gao</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/u011523762/article/details/67638528","strategy":"BlogCommendFromBaidu","index":"47"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u011523762/article/details/67638528","strategy":"BlogCommendFromBaidu","index":"47"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u011523762/article/details/67638528" target="_blank" title="Windows下 MySQL装载时区">
		<h4 class="text-truncate oneline">
				Windows下 <em>MySQL</em>装载<em>时区</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-28</span>
				<span class="read-num hover-hide">
					阅读数 
					1208</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u011523762/article/details/67638528" target="_blank" title="Windows下 MySQL装载时区">
				<span class="desc oneline">默认情况下MySQL不装载时区，自动采用系统时区。windows下装载时区的办法：1.从http://dev.mysql.com/downloads/timezones.html页面下载时区文件；2....</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u011523762">来自：	<span class="blog_title"> Keaper的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/weitao_11/article/details/53943425","strategy":"BlogCommendFromBaidu","index":"48"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weitao_11/article/details/53943425","strategy":"BlogCommendFromBaidu","index":"48"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weitao_11/article/details/53943425" target="_blank" title="mysql 时区报错">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>时区</em>报错		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-30</span>
				<span class="read-num hover-hide">
					阅读数 
					375</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weitao_11/article/details/53943425" target="_blank" title="mysql 时区报错">
				<span class="desc oneline">mysqlUnknownorincorrecttimezone:'Asia/Shanghai'mysql时区有问题找了好久只有linux的版本都说是：mysql_tzinfo_to_sql/usr/s...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weitao_11">来自：	<span class="blog_title"> weitao_11的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_68" data-pid="68" data-track-view='{"mod":"kp_popu_68-654","con":",,"}' data-track-click='{"mod":"kp_popu_68-654","con":",,"}' data-report-view='{"mod":"kp_popu_68-654","keyword":""}' data-report-click='{"mod":"kp_popu_68-654","keyword":""}'><div id="three_ad48" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad48",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_387","dest":"https://blog.csdn.net/csdnhsh/article/details/91357986","strategy":"BlogCommendFromBaidu","index":"49"}' data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/csdnhsh/article/details/91357986","strategy":"BlogCommendFromBaidu","index":"49"}'>
	<div class="content">
		<a href="https://blog.csdn.net/csdnhsh/article/details/91357986" target="_blank" title="修改MySQL的时区，涉及参数time_zone">
		<h4 class="text-truncate oneline">
				修改<em>MySQL</em>的<em>时区</em>，涉及参数time_zone		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-10</span>
				<span class="read-num hover-hide">
					阅读数 
					104</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/csdnhsh/article/details/91357986" target="_blank" title="修改MySQL的时区，涉及参数time_zone">
				<span class="desc oneline">首先需要查看mysql的当前时区,用time_zone参数mysql&amp;gt;showvariableslike'%time_zone%';+------------------+--------+|V...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/csdnhsh">来自：	<span class="blog_title"> csdn's blog</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
                <div class="recommend-item-box type_hot_word">
                                <div class="content clearfix">
                    <div class="word float-left">
                                                            <span>
                        <a href="https://edu.csdn.net/courses/o5329_s5330_k " target="_blank">
                        机器学习教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/courses/o280_s351_k " target="_blank">
                        Objective-C培训                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o7115_s388_l0_t " target="_blank">
                        交互设计视频教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/course/play/5599/104252 " target="_blank">
                        颜色模型                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o363_l0_t " target="_blank">
                        设计制作学习                    </a></span>
                                                            </div>
                </div>
                                                <div class="content clearfix">
                    <div class="float-left">
                                        <span>
                        <a href="https://www.csdn.net/gather_24/MtTaEg3sMDM5MS1ibG9n.html" target="_blank">
                        mysql关联查询两次本表</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_10/MtjaIg3sMTUzMy1kb3dubG9hZAO0O0OO0O0O.html" target="_blank">
                        native底部 react</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_1b/Ntzagg1sOTU3LWRvd25sb2Fk.html" target="_blank">
                        extjs glyph 图标</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/MtjaYgxsODAtZWR1.html" target="_blank">
                        课程表数据库设置</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/MtzaQgysNTMtZWR1.html" target="_blank">
                        物联网专业课程设置</a>
                    </span>
                                        </div>
                </div>
                                </div>
                            <div class="recommend-loading-box">
                <img src='https://csdnimg.cn/release/phoenix/images/feedLoading.gif'>
            </div>
            <div class="recommend-end-box">
                <p class="text-center">没有更多推荐了，<a href="https://blog.csdn.net/" class="c-blue c-blue-hover c-blue-focus">返回首页</a></p>
            </div>
        </div>
    </main>

    <aside>
	<div id="asideProfile" class="aside-box">
    <!-- <h3 class="aside-title">个人资料</h3> -->
    <div class="profile-intro d-flex">
        <div class="avatar-box d-flex justify-content-center flex-column">
            <a href="https://blog.csdn.net/u010305706">
              <img src="https://avatar.csdn.net/B/7/A/3_u010305706.jpg" class="avatar_pic">
                              <img src="https://g.csdnimg.cn/static/user-reg-year/1x/6.png" class="user-years">
                          </a>
            
        </div>
        <div class="user-info d-flex justify-content-center flex-column">
            <p class="name csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                <a href="https://blog.csdn.net/u010305706"  class="" id="uid">peach_li</a>
            </p>
                    </div>
                <div class="opt-box d-flex justify-content-center flex-column">
            <span  class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                                    <a class="btn btn-sm btn-red-hollow attention" id="btnAttent">关注</a>
                            </span>
        </div>
            </div>
    <div class="data-info d-flex item-tiling">
                <dl class="text-center" title="147">
                        <dt><a href="https://blog.csdn.net/u010305706?t=1">原创</a></dt>
            <dd><a href="https://blog.csdn.net/u010305706?t=1"><span class="count">147</span></a></dd>
                    </dl>
        <dl class="text-center" id="fanBox" title="41">
            <dt>粉丝</dt>
            <dd><span class="count" id="fan">41</span></dd>
        </dl>
        <dl class="text-center" title="44">
            <dt>喜欢</dt>
            <dd><span class="count">44</span></dd>
        </dl>
        <dl class="text-center" title="17">
            <dt>评论</dt>
            <dd><span class="count">17</span></dd>
        </dl>
    </div>
    <div class="grade-box clearfix">
        <dl>
            <dt>等级：</dt>
            <dd>
                <a href="https://blog.csdn.net/home/help.html#level" title="5级,点击查看等级说明" target="_blank">
                    <svg class="icon icon-level" aria-hidden="true">
                        <use xlink:href="#csdnc-bloglevel-5"></use>
                    </svg>
                </a>
            </dd>
        </dl>
        <dl>
            <dt>访问：</dt>
            <dd title="293421">
                29万+            </dd>
        </dl>
        <dl>
            <dt>积分：</dt>
            <dd title="4030">
                4030            </dd>
        </dl>
        <dl title="13926">
            <dt>排名：</dt>
            <dd>1万+</dd>
        </dl>
    </div>
        <div class="badge-box d-flex">
        <span>勋章：</span>
        <div class="badge d-flex">
                                                        <div class="icon-badge" title="持之以恒">
                       <div class="mouse-box">
                          <img src="https://g.csdnimg.cn/static/user-medal/chizhiyiheng.svg" alt="">
                          <div class="icon-arrow"></div>
                       </div>
                       <div class="grade-detail-box">
                           <div class="pos-box">
                               <div class="left-box d-flex justify-content-center align-items-center flex-column">
                                    <img src="https://g.csdnimg.cn/static/user-medal/chizhiyiheng.svg" alt="">
                                   <p>持之以恒</p>
                               </div>
                               <div class="right-box">
                                   授予每个自然月内发布4篇或4篇以上原创或翻译IT博文的用户。不积跬步无以至千里，不积小流无以成江海，程序人生的精彩需要坚持不懈地积累！                               </div>
                           </div>
                       </div>
                   </div>
                                                             <div class="icon-badge" title="勤写标兵Lv1">
                       <div class="mouse-box">
                          <img src="https://g.csdnimg.cn/static/user-medal/qinxiebiaobing_l1_t1.svg" alt="">
                          <div class="icon-arrow"></div>
                       </div>
                       <div class="grade-detail-box">
                           <div class="pos-box">
                               <div class="left-box d-flex justify-content-center align-items-center flex-column">
                                    <img src="https://g.csdnimg.cn/static/user-medal/qinxiebiaobing_l1_t1.svg" alt="">
                                   <p>勤写标兵Lv1</p>
                               </div>
                               <div class="right-box">
                                   授予每个自然周发布1篇到3篇原创IT博文的用户。本勋章将于次周周三上午根据用户上周的博文发布情况由系统自动颁发。                               </div>
                           </div>
                       </div>
                   </div>
                                             </div>
        <script>
            (function ($) {
                setTimeout(function(){
                    $('div.icon-badge.show-moment').removeClass('show-moment');
                }, 5000);
            })(window.jQuery)
        </script>
    </div>
        <div class="personal-home-page"><a target="_blank"  href="https://me.csdn.net/u010305706">TA的个人主页 ></a></div>
</div>
<div class="csdn-tracking-statistics mb8 box-shadow" data-pid="blog" data-report-click='{"mod":"popu_4"}' data-report-view='{"mod":"popu_4"}' style="height:250px;">
    <div class="aside-content text-center" id="cpro_u2734133">
      <div id="kp_box_56" data-pid="56" data-track-view='{"mod":"kp_popu_56-703","con":",,"}' data-track-click='{"mod":"kp_popu_56-703","con":",,"}' data-report-view='{"mod":"kp_popu_56-703","keyword":""}' data-report-click='{"mod":"kp_popu_56-703","keyword":""}'><script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 博客内页左上视窗-20181120 -->
<ins class="adsbygoogle"
     style="display:inline-block;width:300px;height:250px"
     data-ad-client="ca-pub-1076724771190722"
     data-ad-slot="7700527946"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div>    </div>
</div>
<div id="asideNewArticle" class="aside-box">
    <h3 class="aside-title">最新文章</h3>
    <div class="aside-content">
        <ul class="inf_list clearfix csdn-tracking-statistics tracking-click" data-mod="popu_382">
                        <li class="clearfix">
                <a href="https://blog.csdn.net/u010305706/article/details/90642729" target="_blank" >
                                        轻松快速安装Kubernetes &amp;&amp; dashboard                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/u010305706/article/details/81280806" target="_blank" >
                                        open和fopen的区别详解                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/u010305706/article/details/80678671" target="_blank" >
                                        DVR 原理解析及OpenStack中应用流表分析                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/u010305706/article/details/61922994" target="_blank" >
                                        pdb 调试+ PyCharm+PyDev 调试                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/u010305706/article/details/54407347" target="_blank" >
                                        VDC介绍                </a>
            </li>
                    </ul>
    </div>
</div>
<div id="asideCategory" class="aside-box flexible-box">
    <h3 class="aside-title">个人分类</h3>
    <div class="aside-content">
        <ul>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/u010305706/article/category/3034527">
                    <span class="title oneline">leetcode</span>
                    <span class="count float-right">65篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/u010305706/article/category/3049071">
                    <span class="title oneline">python</span>
                    <span class="count float-right">15篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/u010305706/article/category/3058463">
                    <span class="title oneline">poj</span>
                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/u010305706/article/category/3076271">
                    <span class="title oneline">数据库</span>
                    <span class="count float-right">9篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/u010305706/article/category/5732307">
                    <span class="title oneline">linux</span>
                    <span class="count float-right">11篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/u010305706/article/category/5780177">
                    <span class="title oneline">database</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/u010305706/article/category/5872925">
                    <span class="title oneline">java</span>
                    <span class="count float-right">32篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/u010305706/article/category/5872989">
                    <span class="title oneline">书单</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/u010305706/article/category/5985925">
                    <span class="title oneline">sublime</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/u010305706/article/category/5998259">
                    <span class="title oneline">OpenStack</span>
                    <span class="count float-right">14篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/u010305706/article/category/6120407">
                    <span class="title oneline">algorithm</span>
                    <span class="count float-right">12篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/u010305706/article/category/6151562">
                    <span class="title oneline">JVM</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/u010305706/article/category/6156032">
                    <span class="title oneline">ceilometer</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/u010305706/article/category/6202313">
                    <span class="title oneline">web</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/u010305706/article/category/6211758">
                    <span class="title oneline">mac</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/u010305706/article/category/6246949">
                    <span class="title oneline">运维/自动部署</span>
                    <span class="count float-right">11篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/u010305706/article/category/6294026">
                    <span class="title oneline">TCP-IP</span>
                    <span class="count float-right">10篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/u010305706/article/category/6320970">
                    <span class="title oneline">docker</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/u010305706/article/category/6366085">
                    <span class="title oneline">K8s</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/u010305706/article/category/7888384">
                    <span class="title oneline">C语言</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideArchive" class="aside-box flexible-box">
    <h3 class="aside-title">归档</h3>
    <div class="aside-content">
        <ul class="archive-list">
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2019/05">
                    2019年5月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2018/07">
                    2018年7月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2018/06">
                    2018年6月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2017/03">
                    2017年3月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2017/01">
                    2017年1月                    <span class="count float-right">7篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2016/12">
                    2016年12月                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2016/11">
                    2016年11月                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2016/10">
                    2016年10月                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2016/08">
                    2016年8月                    <span class="count float-right">6篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2016/07">
                    2016年7月                    <span class="count float-right">15篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2016/06">
                    2016年6月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2016/05">
                    2016年5月                    <span class="count float-right">14篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2016/04">
                    2016年4月                    <span class="count float-right">22篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2016/03">
                    2016年3月                    <span class="count float-right">46篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2016/02">
                    2016年2月                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2016/01">
                    2016年1月                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2015/12">
                    2015年12月                    <span class="count float-right">6篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2015/11">
                    2015年11月                    <span class="count float-right">8篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2015/10">
                    2015年10月                    <span class="count float-right">20篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2015/09">
                    2015年9月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2015/08">
                    2015年8月                    <span class="count float-right">8篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2015/05">
                    2015年5月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2015/04">
                    2015年4月                    <span class="count float-right">6篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010305706/article/month/2015/03">
                    2015年3月                    <span class="count float-right">4篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideHotArticle" class="aside-box">
	<h3 class="aside-title">热门文章</h3>
	<div class="aside-content">
		<ul class="hotArticle-list csdn-tracking-statistics tracking-click" data-report-view='{"mod":"popu_521"}'>
							<li>

					<a href="https://blog.csdn.net/u010305706/article/details/48129131" >
                                                MongoDb 命令查询所有数据库列表                    </a>
					<p class="read">阅读数 <span>39292</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/u010305706/article/details/47837861" >
                                                python 打开文件，写入文件，关闭文件，读文件，清空文件内容                    </a>
					<p class="read">阅读数 <span>15420</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/u010305706/article/details/51509271" >
                                                puppet学习与精通之入门                    </a>
					<p class="read">阅读数 <span>14701</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/u010305706/article/details/52206175" >
                                                别以为真懂Openstack: 虚拟机创建的50个步骤和100个知识点                    </a>
					<p class="read">阅读数 <span>13412</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/u010305706/article/details/54407347" >
                                                VDC介绍                    </a>
					<p class="read">阅读数 <span>12894</span></p>
				</li>
					</ul>
	</div>
</div>
<div id="asideNewComments" class="aside-box">
    <h3 class="aside-title">最新评论</h3>
    <div class="aside-content">
        <ul class="newcomment-list">
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/u010305706/article/details/51252817#comments">python import 缺少解...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/weixin_44711004" class="user-name" target="_blank">weixin_44711004：</a>解决 感谢                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/u010305706/article/details/48129131#comments">MongoDb 命令查询所有数据库...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/yuan_618859" class="user-name" target="_blank">yuan_618859：</a>感谢博主，厉害了                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/u010305706/article/details/47837725#comments">python实现一个文件传递参数并...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/donove" class="user-name" target="_blank">donove：</a>你好，如果需要传递多个参数应该怎么写？                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/u010305706/article/details/54406060#comments">Region和Available ...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/weixin_43708981" class="user-name" target="_blank">weixin_43708981：</a>感谢                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/u010305706/article/details/50070731#comments">sublime 快捷键大全</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/afei__" class="user-name" target="_blank">afei__：</a>不错的总结                </p>
            </li>
                    </ul>
    </div>
</div>
	<div id="asideFooter">
			
		<div class="aside-box">
			<div id="kp_box_57" data-pid="57" data-track-view='{"mod":"kp_popu_57-77","con":",,"}' data-track-click='{"mod":"kp_popu_57-77","con":",,"}' data-report-view='{"mod":"kp_popu_57-77","keyword":""}' data-report-click='{"mod":"kp_popu_57-77","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3163270",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div>		</div>
				<div class="aside-box">
			<div class="persion_article">
			</div>
		</div>
	</div>
</aside>
<script src="https://csdnimg.cn/pubfooter/js/publib_footer-1.0.3.js" data-isfootertrack="false" type="text/javascript"></script>
<script>
	$("a.flexible-btn").click(function(){
		$(this).parents('div.aside-box').removeClass('flexible-box');
		$(this).remove();
	})
</script>
</div>
<div class="mask-dark"></div>
<div class="tool-box vertical">
    	<ul class="meau-list">
		<li class="btn-like-box ">
			<button class=" low-height hover-box btn-like " title="点赞">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup"></use>
				</svg>
				<span class="hover-show text-box text">
					<span class="no-active">点赞</span>
					<span class="active">取消点赞</span>
				</span>
				<p id="supportCount">0</p>
			</button>
		</li>
		<li class="to-commentBox">
						<a class="btn-comments low-height hover-box" title="写评论" href="#commentBox">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-comments"></use>
				</svg>
				<span class="hover-show text">评论</span>
				<p class="">
										</p>
			</a>
		</li>
		<li class="toc-container-box" id="liTocBox">
			<a class="btn-toc low-height hover-box btn-comments" title="目录">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-contents"></use>
				</svg>
				<span class="hover-show text">目录</span>
			</a>
			<div class="toc-container">
				<div class="pos-box">
					<div class="icon-arrow"></div>
					<div class="scroll-box">
						<div class="toc-box"></div>
					</div>
				</div>
				<div class="opt-box">
					<button class="btn-opt prev nomore" title="向上">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevronup"></use>
						</svg>
					</button>
					<button class="btn-opt next">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevrondown"></use>
						</svg>
					</button>
				</div>
			</div>
		</li>
		<li>
			<a class="btn-bookmark low-height hover-box btn-comments" title="收藏">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark"></use>
				</svg>
					<span class="hover-show text">收藏</span>
				<!-- <span class="hover-show text-box text">
					<span class="no-active">收藏</span>
					<span class="active">取消收藏</span>
				</span> -->
			</a>
		</li>
		<li class="bdsharebuttonbox">
			<div class="weixin-qr btn-comments low-height hover-box" >
        <a href="#" class="bds_weixin clear-share-style" data-cmd="weixin" title="手机看"></a>
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-usephone"></use>
				</svg>
				<span class="hover-show text text3">
					手机看
				</span>
			</div>
		</li>
							<li class="widescreen-hide">
				<a class="prev btn-comments low-height hover-box" href="https://blog.csdn.net/u010305706/article/details/52985993" title="ssh 携带密码登录-sshpass">
					<svg class="icon hover-hide" aria-hidden="true">
						<use xlink:href="#csdnc-chevronleft"></use>
					</svg>
					<span class="hover-show text text3">上一篇</span>
				</a>
			</li>
								<li class="widescreen-hide">
			<a class="next btn-comments hover-box low-height" href="https://blog.csdn.net/u010305706/article/details/52998970" title="python mysql数据库插入timestamp">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-chevronright"></use>
				</svg>
				<span class="hover-show text text3">下一篇</span>
			</a>
		</li>
						<!-- 宽屏更多按钮 -->
		<li class="widescreen-more">
			<a class="btn-comments chat-ask-button low-height hover-box" title="快问" href="#chatqa">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-more"></use>
				</svg>
				<span class="hover-show text">更多</span>
				
			</a>
			<ul class="widescreen-more-box">
													<li class="widescreen-more">
						<a class="btn-comments low-height hover-box" href="https://blog.csdn.net/u010305706/article/details/52985993" title="ssh 携带密码登录-sshpass">
							<svg class="icon hover-hide" aria-hidden="true">
								<use xlink:href="#csdnc-chevronleft"></use>
							</svg>
							<span class="hover-show text text3">上一篇</span>
						</a>
					</li>
																<li class="widescreen-more">
					<a class="btn-comments hover-box low-height" href="https://blog.csdn.net/u010305706/article/details/52998970" title="python mysql数据库插入timestamp">
						<svg class="icon hover-hide" aria-hidden="true">
							<use xlink:href="#csdnc-chevronright"></use>
						</svg>
						<span class="hover-show text text3">下一篇</span>
					</a>
				</li>
							</ul>
		</li>
	</ul>
</div>
<script>window._bd_share_config = { "common": { "bdSnsKey": {}, "bdText": "", "bdMini": "1", "bdMiniList": false, "bdPic": "", "bdStyle": "0", "bdSize": "16" }, "share": {} }; with (document) 0[(getElementsByTagName('head')[0] || body).appendChild(createElement('script')).src = 'https://csdnimg.cn/static/api/js/share.js?v=89860594'];</script>
<script src="https://g.csdnimg.cn/collection-box/1.0.0/collection-box.js?t=20190710173809" type="text/javascript"></script><script>
    var recommendCount = 50;
    recommendCount = recommendCount > 1 ? (recommendCount + (recommendCount>6 ? 2 : 1)) : recommendCount;
    var ChannelId = 6;
    var articleId = "52998947";
    var commentscount = 0;
    var islock = false;
    var curentUrl = "https://blog.csdn.net/u010305706/article/details/52998947";
    var myUrl = "https://my.csdn.net/";
    //1禁止评论，2正常
    var commentAuth = 2;
    //百度搜索
    var baiduKey = "MySQL时区设置 - peachli";
    var needInsertBaidu = true;
    // 代码段样式
    var codeStyle = '';
	var highlight = ["mysql","\u65f6\u533a","\u8bbe\u7f6e"];//高亮数组

    var RecommendBlogExpertList = [];
	var articleType = 1;
	var CopyrightContent = '本文为博主原创文章，未经博主允许不得转载。';
</script>
<script src="https://csdnimg.cn/public/sandalstrap/1.4/js/sandalstrap.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-3d3b805766.js"></script>


<div style="display:none;">
	<img src="" onerror='setTimeout(function(){if(!/(csdn.net|iteye.com|baiducontent.com|googleusercontent.com|360webcache.com|sogoucdn.com|bingj.com|baidu.com)$/.test(window.location.hostname)){window.location.href="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x77\x77\x77\x2e\x63\x73\x64\x6e\x2e\x6e\x65\x74"}},3000);'>
</div>
</body>

	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/codesnippet/lib/highlight/styles/atom-one-light.css">
	<script type="text/javascript" src="https://csdnimg.cn/release/phoenix/production/pc_wap_common-f868939e52.js" /></script>

<script src="https://csdnimg.cn/release/phoenix/template/js/common-37b7aadaf4.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/template/js/detail-1e5a65cde8.min.js"></script>

	<script src="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-fc7383b956.min.js"></script>
<script>
 // 全局声明
 if (window.csdn === undefined) {
      window.csdn = {};
    }
    window.csdn.sideToolbar = {
        options: {
            report:{
                isShow: true,
            },
            afterFinished: function(){
                setTimeout(function () {
                    var viphtml = '<a class="option-box" data-type="vip" href="https://mall.csdn.net/vip" target="_blank">'+
                        '<img src="https://g.csdnimg.cn/side-toolbar/1.4/images/vip.png" alt="" srcset="">'+
                        '<span class="show-txt">VIP<br>免广告</span>'+
                        '</a>';
                    $('.csdn-side-toolbar').prepend(viphtml)
                },300)
            }
        }
    }

    $(function(){
        $(document).on('click',"a.option-box[data-type='report']",function() {
            showReport(false,articleTitles)
        });
    })
</script>
<script src="https://g.csdnimg.cn/side-toolbar/1.4/side-toolbar.js"></script>

    <script src="//g.csdnimg.cn/??login-box/1.0.6/login-box.js,login-box/1.0.7/login-auto.js,copyright/1.0.3/copyright.js,baidu-search/1.0.0/baidu-search.js?t=20190307095522"  type="text/javascript"></script>

<script type="text/javascript" src="https://csdnimg.cn/release/blog_mathjax/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
<script type="text/x-mathjax-config">
    MathJax.Hub.Config({
            "HTML-CSS": {
                    linebreaks: { automatic: true, width: "94%container" },
                    imageFont: null
            },
            tex2jax: {
                preview: "none"
            },
            mml2jax: {
                preview: 'none'
            }
    });
</script>
<script type="text/javascript">
    </script>
<script src="https://gh.bdstatic.com/static/gh/js/sdk/bword.min.js"></script>
</html>
